<?php
#
#
# Copyright TEDECO, 2009. http://tedeco.fi.upm.es
#
# This file is part of kumenya.
#
# Kumenya is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# Kumenya is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with Foobar.  If not, see <http://www.gnu.org/licenses/>.
#
#
#
?>
<?php

// DEFINITIONS OF THE DATA BASE
	define ('Library','library');
	define ('Enrollment','enrollment');
	define ('Accountancy','accountancy');

// LIBRARY DB DEFINITIONS
	define ('StudentsTable','students');
	define ('EntriesTable','entries');
	define ('StudentsToRegisterTable','awaitingregistrations');
	define ('AmortizationsTable','amortizations');
	define ('ArticlesTable','articles');
	define ('UnitsTable','units');
	define ('DegreesTable','degrees');
	define ('CategoriesTable','categories');
	define ('ClassesTable','classes');
	define ('AmortizationCategoryTable','propertyclasses');
	define ('WorkingConditionsTable','conditions');	
	define ('ConfigurationTable','configuration');	
	define ('AccountingAccountsTable','accountingaccounts');	
	define ('BankAccountsTable','bankaccounts');	
	define ('DeductionsTable','eventualities');
	define ('DocumentsTable','documents');
	define ('FacultiesTable','faculties');
	define ('BooksTable','books');
	define ('TownsTable','towns');
	define ('RegistrationsTable','registrations');
	define ('TransactionsTable','transactions');
	define ('MarksTable','unitsregistration');
	define ('OrganizationsTable','organizations');
	define ('CountriesTable','countries');
	define ('ParametersTable','parameters');
	define ('PASTable','pas');
	define ('PeopleTable','people');
	define ('LoansTable','loans');
	define ('ProceduresTable','procedimientos');
	define ('TeachersTable','teachers');
	define ('ProvincesTable','provinces');
	define ('BranchesTable','branches');
	define ('TablaDeReservas','reserve');
	define ('MagazinesTable','magazinesnewspapers');
	define ('TypesTable','transactionstypes');
	define ('UsersTable','users');

//HUMANIZATION DEFINITIONS
	define ('Subscription','Subscription');
	define ('Year', 'Year');
	define ('PubYear','PubYear');
	define ('ALevelsYear','ALevelsYear');
	define ('AccountingYear','AccountingYear');
	define ('DegreeYears','DegreeYears');
	define ('UndergradYears','UndergradYears');
	define ('Annual','Annual');
	define ('Pass','Pass');
	define ('RegistrationDebitEntry','RegistrationDebitEntry');
	define ('RegistrationFeeDebitEntry','RegistrationFeeDebitEntry');
	define ('NetTaxEntry','NetTaxEntry');
	define ('DSSEmployeeEntry','DSSEmployeeEntry');
	define ('DSSEmployerEntry','DSSEmployerEntry');
	define ('BenefitsOfficeEmployee','BenefitsOfficeEmployee');
	define ('BenefitsOfficeEmployer','BenefitsOfficeEmployer');
	define ('OtherDeductionsEntry','OtherDeductionsEntry');
	define ('OthersInstallmentsEntry','OthersInstallmentsEntry');
	define ('GrossSalaryEntry','GrossSalaryEntry');
	define ('NetSalaryEntry','NetSalaryEntry');
	define ('Article','Article');
	define ('RelocationHelp','RelocationHelp');
	define ('FamilyHelp','FamilyHelp');	
	define ('HousingHelp','HousingHelp');
	define ('GovernmentGrant','GovernmentGrant');
	define ('Gross','Gross');
	define ('ChangeFBUUSD','ChangeFBUUSD');
	define ('Married','Married');
	define ('Degree','Degree');
	define ('Category','Category');
	define ('Categories','Categories');
	define ('RecognizedCertificate','RecognizedCertificate');
	define ('Code', 'Code');
	define ('SourceCode','SourceCode');
	define ('PersonCode','PersonCode');
	define ('Columns','Columns');
	define ('Purchased','Purchased');
	define ('Password','Password');
	define ('NewPassword','NewPassword');
	define ('OldPassword','OldPassword');
	define ('RepeatedPassword','RepeatedPassword');
	define ('Accredited','Accredited');
	define ('CutOffMarkFail','CutOffMarkFail');
	define ('CutOffMarkRetakers','CutOffMarkRetakers');
	define ('FourMonthly','FourMonthly');
	define ('Course','Course');
	define ('DaysWorked','DaysWorked');
	define ('ALevelCertificate','ALevelCertificate');
	define ('Address', 'Address');
	define ('PlaceOfPub','PlaceOfPub');
	define ('Available','Available');
	define ('Divorced','Divorced');
	define ('CompleteDocumentation','CompleteDocumentation');
	define ('Donated','Donated');
	define ('UnitLength','UnitLength');
	define ('ALevelSchool','ALevelSchool');
	define ('Spanish','Spanish');
	define ('IsMagazine', 'IsMagazine');
	define ('State','State');
	define ('MaritalStatus','MaritalStatus');
	define ('UniversityDegree','UniversityDegree');
	define ('EvGrossSubscription','EvGrossSubscription');
	define ('EvNetSubscription','EvNetSubscription');
	define ('EvGrossDiscount','EvGrossDiscount');
	define ('EvNetDiscount','EvNetDiscount');
	define ('Exploitation','Exploitation');
	define ('Fascicle', 'Fascicle');
	define ('YearEndingDate','YearEndingDate');
	define ('CourseEndingDate','CourseEndingDate');
	define ('PurchasingDate','PurchasingDate');
	define ('ReturnDate', 'ReturnDate');
	define ('EmissionDate', 'EmissionDate');
	define ('EndDate', 'EndDate');
	define ('DraftEndDate','DraftEndDate');
	define ('StartDate','StartDate');
	define ('CourseStartingDate','CourseStartingDate');
	define ('TransactionDate','TransactionDate');
	define ('DateOfBirth','DateOfBirth');
	define ('SubscriptionDate', 'SubscriptionDate');
	define ('French', 'French');
	define ('Expenses','Expenses');
	define ('Management','Management');
	define ('ThereIsSanction', 'ThereIsSanction');
	define ('Man','Man');
	define ('Identification','Identification');
	define ('GrossTax','GrossTax');
	define ('NetTax','NetTax');
	define ('Income','Income');
	define ('Inscription','Inscription');
	define ('HeadStudies','HeadStudies');
	define ('Kirundi','Kirundi');
	define ('PlaceOfBirth','PlaceOfBirth');
	define ('Registration','Registration');
	define ('HonorableMention','HonorableMention');
	define ('NationalCurrency','NationalCurrency');
	define ('ForeignCurrency','ForeignCurrency');
	define ('Woman','Woman');
	define ('MutualEmployee','MutualEmployee');
	define ('MutualStandard','MutualStandard');
	define ('Net','Net');
	define ('none','none');
	define ('None','None');
	define ('No','No');
	define ('UnitName','UnitName');
	define ('ClassName','ClassName');
	define ('SpouseName','SpouseName');
	define ('AccountName','AccountName');
	define ('FontName','FontName');
	define ('MotherName','MotherName');
	define ('FatherName','FatherName');
	define ('ExtraMark','ExtraMark');
	define ('FinalMark','FinalMark');
	define ('MaximumMark','MaximumMark');
	define ('FirstMark','FirstMark');
	define ('SecondMark','SecondMark');
	define ('Number', 'Number');
	define ('ClassNumber','ClassNumber');
	define ('AccountNumber','AccountNumber');
	define ('NumberCopies', 'NumberCopies');
	define ('PDFNumber','PDFNumber');
	define ('IdentificationNum','IdentificationNum');
	define ('Mandatory','Mandatory');
	define ('Observations','Observations');
	define ('Optional','Optional');
	define ('Organization','Organization');
	define ('FatherTransaction','FatherTransaction');
	define ('Pages', 'Page');
	define ('Country','Country');
	define ('Countries','Countries');
	define ('KeyWords','KeyWords');
	define ('KeyWordsNo', 'KeyWordsNo');	
	define ('KeyWordsYes', 'KeyWordsYes');
	define ('Passive','Passive');
	define ('Lost','Lost');
	define ('Newspaper','Newspaper');
	define ('Person','Person');
	define ('Town','Town');
	define ('Weighting','Weighting');
	define ('Percentage','Percentage');
	define ('ApprovedPercentage','ApprovedPercentage');
	define ('ApprovedPercentageComplement','ApprovedPercentageComplement');
	define ('ForeignPrice','ForeignPrice');
	define ('LowerPrice','LowerPrice');
	define ('NationalPrice','NationalPrice');
	define ('HigherPrice','HigherPrice');
	define ('Lent','Lent');
	define ('first','first');
	define ('MotherOccupation','MotherOccupation');
	define ('FatherOccupation','FatherOccupation');
	define ('ALevelSpecialisation','ALevelSpecialisation');
	define ('Rector','Rector');
	define ('Region','Region');
	define ('Reserved','Reserved');
	define ('ALevelResult','ALevelResult');
	define ('Stolen','Stolen');
	define ('NetSalary','NetSalary');
	define ('DebitBalance','DebitBalance');
	define ('CreditBalance','CreditBalance');
	define ('Sanction', 'Sanction');
	define ('LibrarySanction','LibrarySanction');
	define ('second','second');
	define ('EmployedSocialSecurity','EmployedSocialSecurity');
	define ('SocialSecurityPatron','SocialSecurityPatron');
	define ('HealthInsurance','HealthInsurance');
	define ('HealthInsurancePatr','HealthInsurancePatr');
	define ('SixMonthly','SixMonthly');
	define ('Separated','Separated');
	define ('FirstSession','FirstSession');
	define ('SecondSession','SecondSession');
	define ('ExtraSession','ExtraSession');
	define ('Yes','Yes');
	define ('Situation','Situation');
	define ('Single','Single');
	define ('SSocial','SSocial');
	define ('SSocialPatr','SSocialPatr');
	define ('BaseSalary','BaseSalary');
	define ('GrossIncome','GrossIncome');
	define ('sumOwe','sum(Owe)');
	define ('sumAsset','sum(Asset)');
	define ('RegistrationFee','RegistrationFee');
	define ('LoanTime','LoanTime');
	define ('RequestTime','RequestTime');
	define ('ClassType','ClassType');
	define ('AccountType','AccountType');
	define ('TransactionType','TransactionType');
	define ('PersonType','PersonType');
	define ('ThirdType','ThirdType');
	define ('UserType','UserType');
	define ('Title', 'Title');
	define ('All','All');
	define ('TotalOwe','TotalOwe');
	define ('TotalAsset','TotalAsset');
	define ('TotalCreditorBalance','TotalCreditorBalance');
	define ('TotalDebtorBalance','TotalDebtorBalance');
	define ('Core','Core');
	define ('ClassUid','ClassUid');
	define ('PropertyClassesUid','PropertyClassesUid');
	define ('PreviousUniversity','PreviousUniversity');
	define ('Widowed','Widowed');
		
// DEFINITIONS OF THE CONFIGURATION TABLE
	define ('Scope','Scope');
	define ('Search','Search');
	define ('Field','Field');
	define ('Key','Key');
	define ('PrimaryKey','PRI');
	define ('Column','Column');
	define ('NO','NO');
	define ('AttributeName','AttributeName');
	define ('Null','Null');
	define ('YES','YES');
	define ('ReferencedTable ','ReferenceTable');
	define ('Type','Type');
	define ('DataType','DataType');	
	define ('Value','Value');
	define ('InternalValue','Key');
	define ('ShownValue','Value');	
	
// DEFINITIONS OF TYPES OF DB
	define ('UID','bigint(16) unsigned zerofill');
	define ('Date','date');
	define ('Year','year(4)');
	define ('Integer','int(11)');
	define ('Real', 'float(11,2)');
	define ('Boolean','bit(1)');
	define ('Chain','Chain');
	define ('PasswordType','PasswordType');
	define ('CheckBox','CheckBox');
	
// FIELDS USED BY THE DB AND NOT SHOWN TO THE USER
	define ('Asset','Asset');
	define ('CreationDate','CreationDate');
	define ('ModificationDate','ModificationDate');
	define ('CancellationDate','CancellationDate');
$commonFields = array (Asset,CreationDate,ModificationDate,CancellationDate);

// TYPE OF THE PARAMETERS OF THE DB PROCEEDINGS
	define ('Input','IN');
	define ('Output','OUT');
	define ('InputOutput','INOUT');

// RETURN VALUES OF PROCEEDINGS
	define ('result','result');
	define ('output','output');
	define ('certificate','certificate');
	define ('Error','Error');
	define ('Result','ActionResult');

// TYPES OF USERS
	define ('Tedeco','TEDECO');
	define ('Librarian','Librarian');
	define ('Administrative employee','Administrative employee');
	define ('Dean','Dean');
	define ('FreeAccess','FreeAccess');

// DEFINITIONS OF THE LOGS
	define ("LogDirectory", "../../../log");
	define ("ExtensionLog", ".txt");

// TEMPORARY DIRECTORY
	define ("Temp", "../../tmp/");

// FONTS DIRECTORY
	define ("Fonts", "../../fonts/");
	
?>